UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'g3bQxo0iIB7fzt62B6mVqgT+Dqm7C1qEmudmif5y1B4='
WHERE
key_id = 'ca38b4c50f8ba773880b65151823e55c9bb749fc3dea1be51d191f096e0fc1f8'
AND (
token = 'g3bQxo0iIB7fzt62B6mVqgT+Dqm7C1qEmudmif5y1B4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)