UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HVcAhFMsxzdHVhsLK2HKstJwqe+9lLWLKTGHe+UjL48='
WHERE
key_id = '2782fa3d135211b34398e98f8a4ae1c5889f18eefe9ff1a174040e9923abf8ce'
AND (
token = 'HVcAhFMsxzdHVhsLK2HKstJwqe+9lLWLKTGHe+UjL48='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)