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