UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R0SQSF+cFX0pea/ZA06ZWqhlKot35X7maVFsrp1eKxU='
WHERE
key_id = 'e3c7e2a18c3d67266dd31bb2c60218f66194bb9be90dd46c2ef47c54086097a8'
AND (
token = 'R0SQSF+cFX0pea/ZA06ZWqhlKot35X7maVFsrp1eKxU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)