UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dKiOe2Hb2y1slfRVoBBgPMqykxOhOyW3aFCqAM9wVwc='
WHERE
key_id = 'ee1e7cf676fc25bd658364eccc2db4c3b74d61f2aedc678f1b709b5c1bd10cdd'
AND (
token = 'dKiOe2Hb2y1slfRVoBBgPMqykxOhOyW3aFCqAM9wVwc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)