UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mlDB3j0OyOWUEjKTW7rPIHpiFR5iqzR3JH8tdY3jFWM='
WHERE
key_id = 'e0e67643683905e4d9aa2d3206be9a008c7605dd4fe6d1729758b938352a375f'
AND (
token = 'mlDB3j0OyOWUEjKTW7rPIHpiFR5iqzR3JH8tdY3jFWM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)