UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XjG3iRWz5b52nt9lUCO8XJnF3oNEL+wGEb1YmmEX/68='
WHERE
key_id = 'e734f41d8d87719ff5ac4e663766720951783cd5a29d0c93f9e792aac57e67e0'
AND (
token = 'XjG3iRWz5b52nt9lUCO8XJnF3oNEL+wGEb1YmmEX/68='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)