UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pfJI7bcMmGCqApnj3qJBFB4SwQViUvcbb0lF2V0fiGA='
WHERE
key_id = '9274378cf4b861c34600b88b143bb9277617cabb777da54e70320f98dd439274'
AND (
token = 'pfJI7bcMmGCqApnj3qJBFB4SwQViUvcbb0lF2V0fiGA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)