UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vN9m41yQ4J2YzIAxzZS3LLe0xacd/ayQatXSEu8OuJI='
WHERE
key_id = '50c7d36b1d561d797e40defd6df13eb16c9cbd9acab5b41beaab8617cbbf453b'
AND (
token = 'vN9m41yQ4J2YzIAxzZS3LLe0xacd/ayQatXSEu8OuJI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)