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