UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pIKJsMh/72JULiopOnozwRESTInOijIOeUU1bJpPpJw='
WHERE
key_id = 'cc91386de827b116d9476b3f9d4b0655bdb640d430512016f80427da65262e35'
AND (
token = 'pIKJsMh/72JULiopOnozwRESTInOijIOeUU1bJpPpJw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)