UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LlnK8VLrvYVaw13dR+48VqYMIEsZSIQHUoSofc7VCmA='
WHERE
key_id = 'd59319e6ff40923b5ab7578ef16b03a34d4dad74d033a9c685a8c76a4ce9df06'
AND (
token = 'LlnK8VLrvYVaw13dR+48VqYMIEsZSIQHUoSofc7VCmA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)