UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'haD0g53z4F3qJQdYKUMbtk5d0T5uK0AbkKHfA9inuVk='
WHERE
key_id = '6dfe27dafd65d9cdc0ee2641a8545f32d3ebd95f6807602d6a9d63e8c49fe7a2'
AND (
token = 'haD0g53z4F3qJQdYKUMbtk5d0T5uK0AbkKHfA9inuVk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)