UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0CAFdTrv6x4DgSso25aIklsYmYb11KWly2Vzvnmh9is='
WHERE
key_id = 'c8f2edcf797c8822e4345162ceab02c9d25d760161e76681e1fb3abfa135f8dc'
AND (
token = '0CAFdTrv6x4DgSso25aIklsYmYb11KWly2Vzvnmh9is='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)