UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nHblADZlYkz/IyuwWjPxJLQeNSbmSKfhNrNG5HyAlmg='
WHERE
key_id = '337ce131bea5b21e0bb3a1364a1a93d2c65b38649a3ea28c46e5d592988a6d4a'
AND (
token = 'nHblADZlYkz/IyuwWjPxJLQeNSbmSKfhNrNG5HyAlmg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)