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