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