UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'b4tdfUWuW7YElVyS813yWc2Vz21tWVZyIo2CZZy0zjU='
WHERE
key_id = '0e2368e7c9da1cad3b0d82466d909ede1aacecb0717909c7f7d3d8688cae9769'
AND (
token = 'b4tdfUWuW7YElVyS813yWc2Vz21tWVZyIo2CZZy0zjU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)