UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a8sWOnZENSz5po45/nFed6VHmbM74EBMU8GpUd0pQGM='
WHERE
key_id = 'f12c874120a3b3a6620a7e769c155bcb918b8e53a5c8dd9908de0a10f1397f64'
AND (
token = 'a8sWOnZENSz5po45/nFed6VHmbM74EBMU8GpUd0pQGM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)