UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zKhof+JDXGXHCY8of+uC2yRett3L83DgpHdouS+1C0M='
WHERE
key_id = '84ffa720e4101aae16c26e5b062801da74489b180215856984db027acf5f1524'
AND (
token = 'zKhof+JDXGXHCY8of+uC2yRett3L83DgpHdouS+1C0M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)