UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pYzjA8PeB/Axd/8cx5Ajf3PmnjFEc6zEm9q9Dn/n+c8='
WHERE
key_id = '77a255867242e99114818267ceb5b289fdcbeefc3d88b35196c82a649a169de0'
AND (
token = 'pYzjA8PeB/Axd/8cx5Ajf3PmnjFEc6zEm9q9Dn/n+c8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)