UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hLB27rQkyiz0bW5lDSq8/j8etH8ixaO9UBCsqA7iiU4='
WHERE
key_id = '4b728ba789d9deffa2e66606be6ec98b09ae36c3481a3167759e3c8da13d3d4c'
AND (
token = 'hLB27rQkyiz0bW5lDSq8/j8etH8ixaO9UBCsqA7iiU4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)