UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Nhjn+atgTmMSvYzipfJ1Ji6z6eVCKbCnwl8Siyb0DlA='
WHERE
key_id = 'ec7f43de3309a832ce61d746d7eea73ccd8a955841aa0d14b9e85edac3dcb964'
AND (
token = 'Nhjn+atgTmMSvYzipfJ1Ji6z6eVCKbCnwl8Siyb0DlA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)