UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eW0Dj5ZG9TlZE7g565E3qPUr/uK2od5KFkEsGhs035Y='
WHERE
key_id = 'a1f15e55b81a76b9812c2a48c86d82fa8793cc3586c32d9d9ced48b32df99b18'
AND (
token = 'eW0Dj5ZG9TlZE7g565E3qPUr/uK2od5KFkEsGhs035Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)