UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N3+y3vSgGgyuKbtrSjZu9WZ7RtY+IZduoObIsPo+PZ4='
WHERE
key_id = 'a319104927b60a111de4202dbcbbc9610c2e9e968a94dbb191656b1640de6e92'
AND (
token = 'N3+y3vSgGgyuKbtrSjZu9WZ7RtY+IZduoObIsPo+PZ4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)