UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z2Q8lNVm+vG3VUEcYngYN/ENs7p2KAHT+EQKaFTwRZo='
WHERE
key_id = 'ca53ef33882285c0aa081d5072a747b50acaf692b030369c8240c615d0484177'
AND (
token = 'Z2Q8lNVm+vG3VUEcYngYN/ENs7p2KAHT+EQKaFTwRZo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)