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