UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LsizhXJ3dKiV/S6MCIzSEJ0mT8OWKB18jb0VdSgLLGs='
WHERE
key_id = '270d43b429c97387d78b9e04283c8fbb097b9408a527eceecb014d6afeebc40c'
AND (
token = 'LsizhXJ3dKiV/S6MCIzSEJ0mT8OWKB18jb0VdSgLLGs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)