UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aW3bSr1bA3AowvRi8kaIjCHz5hgz59OMNg0V6WYG7ho='
WHERE
key_id = '6f74bde0c20df717188cec22243599f369b7d4994fca4c9f51ae99d9f5ee6f31'
AND (
token = 'aW3bSr1bA3AowvRi8kaIjCHz5hgz59OMNg0V6WYG7ho='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)