UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Vv9hVKA4TqhcXkpelkz4wUJ6uJUmaNVtO0u1IOrk8Sc='
WHERE
key_id = '5a65b93a7385f86e31187f55abb3096b2f2bef00af72c66345ee20328d170c50'
AND (
token = 'Vv9hVKA4TqhcXkpelkz4wUJ6uJUmaNVtO0u1IOrk8Sc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)