UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QNcCma9C5WzcVkx1KZuH93VpgWgsf7cc9WJ3ZzsPBkw='
WHERE
key_id = '9d7c2a81029dceabb0554d4bed8709ca6b270afed1b66b4175e72895e5aeb202'
AND (
token = 'QNcCma9C5WzcVkx1KZuH93VpgWgsf7cc9WJ3ZzsPBkw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)