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