UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tW0a/z8u5K9uK75Me5Jvxg9n8DdXHZY31369f0lZTuE='
WHERE
key_id = 'd6d7e3507a7c44749d36c45555c13fdc5adf29ab8a88de329c33b66a0a1e49ca'
AND (
token = 'tW0a/z8u5K9uK75Me5Jvxg9n8DdXHZY31369f0lZTuE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)