UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lW/Fhhk1tSRzVGkED6NegxVHOY1fjU/dCGQ6P/DVFWY='
WHERE
key_id = 'd47c53916a321a8fa1e6ee9c1c74a6970f0eb5d0e5ff2d414a90679d571d96f0'
AND (
token = 'lW/Fhhk1tSRzVGkED6NegxVHOY1fjU/dCGQ6P/DVFWY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)