UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tgE4EDkzR1oLx8WxA73BqC3qabPPZ+HbUKLQNPz8eGg='
WHERE
key_id = '156875924a6a7301d6b545cbfa89a79b5aae1d74d1e45b384957fcb07e30be08'
AND (
token = 'tgE4EDkzR1oLx8WxA73BqC3qabPPZ+HbUKLQNPz8eGg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)