UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bsWpcnzVsDWkvTGhexb4kEUOHviz/aF+mlV9Z57AUQE='
WHERE
key_id = 'b1e951e830dbdd5ce6625676a09c35a8810efc767f4b4b0b9bc5b5d372d2241c'
AND (
token = 'bsWpcnzVsDWkvTGhexb4kEUOHviz/aF+mlV9Z57AUQE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)