UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bNfjFQXI0p6uHef45/dmZncm7k6VhD8JdoQZTBThlUE='
WHERE
key_id = '202d0b3d6dfb90ce1404d6cfa176f9cab6b3c33debdb814a61c413a52ea5f92d'
AND (
token = 'bNfjFQXI0p6uHef45/dmZncm7k6VhD8JdoQZTBThlUE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)