UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nkTeYOGrAfqvwjR4iEnc9qAlcxmdl0f2l0uAGbDxIJM='
WHERE
key_id = 'c8e4cfa8ee823f8c24ae7b06f6bb685e60a8def0aa6e4edba7486cf9be8a9f2a'
AND (
token = 'nkTeYOGrAfqvwjR4iEnc9qAlcxmdl0f2l0uAGbDxIJM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)