UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7d/kZMxf8YUPQGlKfSer5pAw1DdV6BiLJR938/KgWW4='
WHERE
key_id = 'b995722fa5a99b0b879eb3587fd543fe101ed435c69879146748c31c2f9b2248'
AND (
token = '7d/kZMxf8YUPQGlKfSer5pAw1DdV6BiLJR938/KgWW4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)