UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qOu9Z9gV6PVcVWEJII9oNYAcH7cCaqZ4+XPa/qZV5Og='
WHERE
key_id = 'f9f07f4b989e1f6d62c75163d28f9af7321b978d7d4a433d8cf0e4fe7fcf0ca0'
AND (
token = 'qOu9Z9gV6PVcVWEJII9oNYAcH7cCaqZ4+XPa/qZV5Og='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)